UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXXnCqXpWPn4D01GZGgnjrEn56xkCdVAON4Gsuw4XNw='
WHERE
key_id = '38667024e6c465131d6eed5b7fc41f0468b202e0a4b057275d2b26911f4d1b59'
AND (
token = 'DXXnCqXpWPn4D01GZGgnjrEn56xkCdVAON4Gsuw4XNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)