UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmh887ZQTIqDmLSbuuMEu68QXctPFCALWDww+W0Z6o8='
WHERE
key_id = 'cc7c3ff27c3a4612affe0b1aa9a1997e2e437283c2331a53cc87573464e89931'
AND (
token = 'fmh887ZQTIqDmLSbuuMEu68QXctPFCALWDww+W0Z6o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)