UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h3jAdWMoXuBEUj5kK1UOQh7F5tbv9PHL7yhJprAkir8='
WHERE
key_id = '96430627ac015b5507f5e4a3ef4576e093c3a09c71f6f3cc7a520ab0bf508d50'
AND (
token = 'h3jAdWMoXuBEUj5kK1UOQh7F5tbv9PHL7yhJprAkir8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)