UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PDVWgo94NRaY6sfvYCy/b9mN0BfjlVlBqOA372XIAOE='
WHERE
key_id = 'b9ebb884dafafa51d962f90a687bc0b60888aa4aae542352e5481cc78b7d6497'
AND (
token = 'PDVWgo94NRaY6sfvYCy/b9mN0BfjlVlBqOA372XIAOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)