UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XXjTPIT0W/CFtDVNJkUVIsc7dXRdQMI8PAJG3zcDS8='
WHERE
key_id = '2abc58dc335bd771cc9059ca57b0d1a82c4c4cd95d333e0c9c1eebf9e3d38200'
AND (
token = '7XXjTPIT0W/CFtDVNJkUVIsc7dXRdQMI8PAJG3zcDS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)