UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rhKnmUzHarlsec0oVKfZE1Al0/hpF4nsDitTZTxgbZ0='
WHERE
key_id = 'bc294f2d425abc2d179821f7f38d1b853c115b1f2afffdbf34b7dda23f3dac4d'
AND (
token = 'rhKnmUzHarlsec0oVKfZE1Al0/hpF4nsDitTZTxgbZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)