UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JjY8stHHXl0i1duh1kI51Xlgd66y4wZwrs+RsS9UdHE='
WHERE
key_id = 'b9ece32b0325bb305d4e6651ffb824ca7b3f95940272fc61c48ec16557aa905e'
AND (
token = 'JjY8stHHXl0i1duh1kI51Xlgd66y4wZwrs+RsS9UdHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)