UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4YzsBkaZYS1jy4AeT3E/TJhzVJ9RZv6pi1HjUjegtVI='
WHERE
key_id = 'b82ab21cea9512aecb5a1d441383906790d49eb1adfa02c25b1239b1f29a69bf'
AND (
token = '4YzsBkaZYS1jy4AeT3E/TJhzVJ9RZv6pi1HjUjegtVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)