UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4FdhO2M0qA0CrDqC21KdYgzfAdkiH8NEEgkBu8czTxI='
WHERE
key_id = '18561e88d6dc6cc63b26dfcf99f1173ea8a3d1c2ed2c0462a2dc9acadcab72e2'
AND (
token = '4FdhO2M0qA0CrDqC21KdYgzfAdkiH8NEEgkBu8czTxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)