UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Fi3vaPnV0sRNj6/tdGFbrRHotBCsBH1W4nN5WmMJjXE='
WHERE
key_id = 'c49afe9ab57e5b1112f74b7dc04f067c8801d78af456af8a4a78590830a6a19b'
AND (
token = 'Fi3vaPnV0sRNj6/tdGFbrRHotBCsBH1W4nN5WmMJjXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)