UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KsmEGHlCnO2ekl13/LhCma2a/9I9zp9ajnmdFbjQAPY='
WHERE
key_id = '0258d5509831b7d0b23e4654e8b37ac4a024414df4fc040a0fd683dc302501dc'
AND (
token = 'KsmEGHlCnO2ekl13/LhCma2a/9I9zp9ajnmdFbjQAPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)