UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qi0NbNUPtjURRrWJgqsAKs+wIC3iWv67xpMUsnOtflo='
WHERE
key_id = '8bfd190b7dad03c49031eeefb3f0da410eb480b2625ba7fc33481b277dd32819'
AND (
token = 'qi0NbNUPtjURRrWJgqsAKs+wIC3iWv67xpMUsnOtflo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)