UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snSl/inaLoPOa1n+ZcC6cgIesfFXeGNt6ePGxrBFRF4='
WHERE
key_id = '18138cbe60d1bd263c02f2611d8a73c8c07884c8fd347f346d92494eafeba9f6'
AND (
token = 'snSl/inaLoPOa1n+ZcC6cgIesfFXeGNt6ePGxrBFRF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)