UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCJ7hSBQIc2yJN5tkU5j2NWDlgzmNWpc07hnGGY/DXg='
WHERE
key_id = 'c5de068bd78292bd9cf9663fa9ba2613cd676318dbd5025a07c51881cce2d805'
AND (
token = 'gCJ7hSBQIc2yJN5tkU5j2NWDlgzmNWpc07hnGGY/DXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)