UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HE+L2svTbxtQbfYjr7ghNhv9TTaLXkFdHGc4rmWDEE='
WHERE
key_id = '7af82200759148f931b1c3aca25a99f06bce717aca20b17928a0cec934c018f7'
AND (
token = '0HE+L2svTbxtQbfYjr7ghNhv9TTaLXkFdHGc4rmWDEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)