UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mwcrXZ6RHalq58EIBn5ZaM6SEFaZcNgJpMgT1aaR7PA='
WHERE
key_id = '6e121b2273d782d9270a86d5854b7875ede6e7148f92245fc5b936d242735e7d'
AND (
token = 'mwcrXZ6RHalq58EIBn5ZaM6SEFaZcNgJpMgT1aaR7PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)