UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IZFXqQUaL3jj3Hms0lN01jjoDZUUR/D24G7m4mGIxyI='
WHERE
key_id = 'e9b30dd12715b4b4873c9d7f3f4971ef6bde7174eb2e8cc3ce2e00d186aad8d4'
AND (
token = 'IZFXqQUaL3jj3Hms0lN01jjoDZUUR/D24G7m4mGIxyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)