UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7aqZ+NPjeRAjsrKT9RYSWS2UnDfc2FjIro7/CqGD40='
WHERE
key_id = 'aa4c146a49c6d83f090353b1d14fcc47bf4c35e3eeb55a234abdcac6bb115260'
AND (
token = 'W7aqZ+NPjeRAjsrKT9RYSWS2UnDfc2FjIro7/CqGD40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)