UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCz1xbQPsDDbc5tazlApUe2uFUjSWJXMdgTRb1pVn44='
WHERE
key_id = '247d658067d073b5ff63446d00a03ef47f813ca24360eb73d85df9517d84a1b1'
AND (
token = 'VCz1xbQPsDDbc5tazlApUe2uFUjSWJXMdgTRb1pVn44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)