UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iZpbhbEow5Kxr2fKyyMmLzE1/ICb7IEM5vw7Z1jk568='
WHERE
key_id = 'c046103852ef9c26842f6e33441064a660bf8a8944ce695962b1990e7d1b6785'
AND (
token = 'iZpbhbEow5Kxr2fKyyMmLzE1/ICb7IEM5vw7Z1jk568='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)