UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+kXHdbu4tLKzzaCWlbOVrXNe6S0et6gZxx6hy0hsRDY='
WHERE
key_id = '0df058aa8bfc07b77187f64c6f3062216c975c287f195e8c96afd0521a6c1af7'
AND (
token = '+kXHdbu4tLKzzaCWlbOVrXNe6S0et6gZxx6hy0hsRDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)