UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JD8VcDnZQw9QiGsrTuWYTFhKEh4B7Kq4ySFcddCqAKw='
WHERE
key_id = 'aa29f739c980e014b865614f22fcc15bd5a30b3b37b40f5d35207a827adaf5de'
AND (
token = 'JD8VcDnZQw9QiGsrTuWYTFhKEh4B7Kq4ySFcddCqAKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)