UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcKwSPfHdcj/ADjWd+K9LTtKxH4C4nSVjO5Yy414v3o='
WHERE
key_id = '6e297c9df1b14515bbcab9cda8ec6608bd79d8c0fad049f8136f4f1d6a3eb1b9'
AND (
token = 'QcKwSPfHdcj/ADjWd+K9LTtKxH4C4nSVjO5Yy414v3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)