UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2XMdUwP3EUP3OmHf7LQ2njqv9S8DFtwRaYpTulXwEI='
WHERE
key_id = '5f3f454cfc6f7c38eb250782431e426c6290df1010af287b07535f245832a680'
AND (
token = 'B2XMdUwP3EUP3OmHf7LQ2njqv9S8DFtwRaYpTulXwEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)