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