UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zte1qUgKr6sR+tH/eqQAmPT9ffzhgG3XE5xN2Ia2TYc='
WHERE
key_id = '0abf8eedf4ba3784e358a80777139fb4dd185d53949d89a19cbed069c6433d6a'
AND (
token = 'zte1qUgKr6sR+tH/eqQAmPT9ffzhgG3XE5xN2Ia2TYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)