UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCATlsgTyXWPjtUbrwTtLc7n30B8GbeFG700wQ0lroM='
WHERE
key_id = '599de1a74185974eb63cadabaa6ff7a764c0925593d3f42930870916980fec25'
AND (
token = 'gCATlsgTyXWPjtUbrwTtLc7n30B8GbeFG700wQ0lroM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)