UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6MX6hlJzXc0JSkHnPqK6dMzhvIA5srf1b+agnaBJh4o='
WHERE
key_id = 'b119f05085a7602c7ba6fc721f61fddd114b4a78b9f99ad9a26bb4068d35e3f9'
AND (
token = '6MX6hlJzXc0JSkHnPqK6dMzhvIA5srf1b+agnaBJh4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)