UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mhsWK6Q/b8Dt1gva7GvxN/ZXig6U966e8Kxn2oyV4k='
WHERE
key_id = 'e0a3abb9a3589e1798c9d5a7ac96cea48dfb60e9d04bee6d9128f9eade8221a3'
AND (
token = '6mhsWK6Q/b8Dt1gva7GvxN/ZXig6U966e8Kxn2oyV4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)